<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
#apDiv1 {	position: absolute;
	width: 1301px;
	height: 165px;
	z-index: 1;
	left: 7px;
	overflow: visible;
}
#apDiv2 {	position: absolute;
	width: 965px;
	height: 67px;
	z-index: 1;
	left: 367px;
	top: 183px;
	overflow: visible;
	background-color: #CCC8FB;
}
#apDiv3 {	position: absolute;
	width: 967px;
	height: 849px;
	z-index: 1;
	left: 366px;
	top: 265px;
	overflow: visible;
	background-color: #CCC8FB;
}
#apDiv5 {	position: absolute;
	width: 353px;
	height: 84px;
	z-index: 1;
	left: 4px;
	top: 266px;
	overflow: visible;
	background-color: #CCC8FB;
}
body {
	background-color: #6C4BF1;
}
body,td,th {
	font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
}
a:link {
	text-decoration: none;
	color: #F2F200;
}
a:visited {
	text-decoration: none;
	color: #F2F200;
}
a:hover {
	text-decoration: none;
}
a:active {
	text-decoration: none;
}
a {
	color: #FF8000;
}
#apDiv3 table tr td a strong {
	color: #FF0000;
}
</style>
</head>

<body>
<div id="apDiv1"><img src="Header.png" alt="" width="1327" height="164" /></div>
<div id="apDiv2">
  <h2> &nbsp;&nbsp;&nbsp;Form Cetak Biaya dan Kirim Barang</h2>
</div>
<div id="apDiv3">
    <h2>Data Konsumen Pengirim</h2>
    <table width="600" border="1">
      <tr>
        <td width="99" align="center"><h3>Kd_Pengiriman</h3></td>
        <td width="99" align="center"><h3>Nama</h3></td>
        <td width="252" align="center"><h3>Alamat</h3></td>
        <td width="104" align="center"><h3>No Telepon</h3></td>
      </tr>
      <?php
		$conn = oci_connect("zipzip", "zipzip", "//localhost/XE");
		if (!$conn) {
			echo "Koneksi Ke Database Gagal";
			exit;
		}
		$q3= "select * from data_konsumen_pengirim where status is null";
		$rs3 = oci_parse($conn,$q3);
		oci_execute($rs3);
		?> 
   		<?php
		while($dt3=oci_fetch_assoc($rs3)){
			
		?>
      <tr>
        <td><?php echo $dt3["KD_PENGIRIMAN"]?></td>
        <td><?php echo $dt3["NAMA"]?></td>
        <td><?php echo $dt3["ALAMAT"]?></td>
        <td><?php echo $dt3["NO_TELEPON"]?></td>
      </tr>
       <?php
		}
		?>
    </table>
    <h2>Data Konsumen Penerima</h2>
    <table width="600" border="1">
      <tr>
        <td width="127" align="center"><h3>Kd_Pengiriman</h3></td>
        <td width="106" align="center"><h3>Nama</h3></td>
        <td width="234" align="center"><h3>Alamat</h3></td>
        <td width="105" align="center"><h3>No Telepon</h3></td>
      </tr>
       <?php
		$q2= "select * from data_konsumen_pengirim where status is null";
		$rs2 = oci_parse($conn,$q2);
		oci_execute($rs2);
		?> 
   		<?php
		while($dt2=oci_fetch_assoc($rs2)){
			
		?>
      <tr>
        <td><?php echo $dt2["KD_PENGIRIMAN"]?></td>
        <td><?php echo $dt2["NAMA"]?></td>
        <td><?php echo $dt2["ALAMAT"]?></td>
        <td><?php echo $dt2["NO_TELEPON"]?></td>
      </tr>
      <?php
		}
		?>
  </table>
    <h2>Data Barang</h2>
    <table width="712" border="1">
      <tr>
        <td width="105" align="center" valign="middle"><h3>Kd_Pengiriman</h3></td>
        <td width="94" align="center" valign="middle"><h3>Nama_Barang</h3></td>
        <td width="50" align="center" valign="middle"><h3>Jumlah</h3></td>
        <td width="68" align="center" valign="middle"><h3>Berat Persautan</h3></td>
        <td width="61" align="center" valign="middle"><h3>Layanan Service</h3></td>
        <td width="91" align="center" valign="middle"><h3>Biaya</h3></td>
        <td width="78" align="center" valign="middle"><h3>Cetak</h3></td>
        <td width="113" align="center" valign="middle"><h3>Status Pengiriman</h3></td>
      </tr>
       <?php
		$q = "select * from data_barang where status is null";
		$rs = oci_parse($conn,$q);
		oci_execute($rs);
		?> 
   		<?php
		while($dt=oci_fetch_assoc($rs)){
			
		?>
      <tr>
        <td><?php echo $dt["KD_PENGIRIMAN"]?></td>
        <td><?php echo $dt["NAMA_BARANG"]?></td>
        <td><?php echo $dt["JUMLAH"]?></td>
        <td><?php echo $dt["BERAT_PER_SATUAN"]?></td>
        <td><?php echo $dt["LAYANAN_SERVICE"]?></td>
        <td><?php echo $dt["BIAYA"]?></td>
        <td align="center"><form id="form1" name="form1" method="post" action="">
          <input type="submit" name="button" id="button" value="Cetak" />
        </form></td>
        <td align="center"><a href="StatusTerkirim.php?kd_pengiriman=<?php echo $dt["KD_PENGIRIMAN"]; ?>"><strong>Terkirim</strong></a></td>
      </tr>
      <?php
		}
		?>
    </table>
    <h2>&nbsp;</h2>
</div>
<div id="apDiv5">
  <table bgcolor="#5A54CF" width="355" border="1">
    <tr>
      <td align="center" style="font-size: 18px"><a href="FormTambahMember.php">Form Tambah Member</a></td>
    </tr>
    <tr>
      <td align="center" style="font-size: 18px"><a href="FormDataBarang.php">Form Data Barang</a></td>
    </tr>
    <tr>
      <td align="center" style="font-size: 18px"><a href="FormCetakBiayaDanKirimBarang.php">Form Cetak Biaya dan Kirim Barang</a></td>
    </tr>
    <tr>
      <td align="center" style="font-size: 18px"><a href="Home.php">Logout</a></td>
    </tr>
  </table>
</div>
</body>
</html>
